psql \dt and table size - Mailing list pgsql-hackers

From Bernd Helmle
Subject psql \dt and table size
Date
Msg-id 11AFCA7F6987BE68E91C000D@[172.26.14.62]
Whole thread Raw
Responses Re: psql \dt and table size
Re: psql \dt and table size
List pgsql-hackers
It stroke me today again, that \dt+ isn't displaying the acurate table size
for tables, since it uses pg_relation_size() till now. With having
pg_table_size() since PostgreSQL 9.0 available, i believe it would be more
useful to have the total acquired storage displayed, including implicit
objects (the mentioned case where it was not very useful atm was a table
with a big TOAST table).

Attached minor patch extends \dt to use pg_table_size() starting with
PostgreSQL 9.0, not sure if we backport such changes though. It would be
interesting for 9.1, however.

--
Thanks

    Bernd
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL
Next
From: Tom Lane
Date:
Subject: Re: Missing semicolon in parser's gram.y